from sqlalchemy import Column, Integer, String, DateTime

from module_admin.entity.do.base import db


class Submission(db.Model):
    __tablename__ = 'sys_submissions'

    # 表注释
    __table_args__ = {'comment': '作业提交表'}

    id = Column(Integer, primary_key=True, autoincrement=True, comment='提交ID')
    submission_file = Column(String(255), nullable=False, comment='提交作业的文件路径或URL')
    grade = Column(Integer, nullable=True, comment='评分')
    assignment_id = Column(Integer, comment='作业ID')
    student_name = Column(String(255), comment='学生ID')
